package com.bdqn.utils;

import org.apache.ibatis.io.Resources;
import org.apache.ibatis.session.SqlSession;
import org.apache.ibatis.session.SqlSessionFactory;
import org.apache.ibatis.session.SqlSessionFactoryBuilder;


import java.io.IOException;
import java.io.InputStream;

/**
 * MyBatisUtil
 * 一次性创建 SqlSessionFactory实例
 *  Administrator  whs
 * @since 2024/6/14
 */
public class MyBatisUtil {

    // 一次性创建 SqlSessionFactory实例
    private static SqlSessionFactory factory;

    static { //通过静态代码块，唯一一次创建SqlSessionFactory 实例

        try {
            InputStream is = Resources.getResourceAsStream("mybatis-config.xml");

            // 构建 SqlSessionFactory
            factory  = new SqlSessionFactoryBuilder().build(is);
        } catch (IOException e) {
            throw new RuntimeException("初始化失败",e);
        }
    }

    // 创建并返回SqlSession 实例
    public static SqlSession createSqlSession() {
        return factory.openSession(false);   // 关闭自动提交开启事务
    }



    /**
     * 关闭方法
     * @param sqlSession
     */
    public static void closeSqlSession(SqlSession sqlSession){
        if (sqlSession != null){
            sqlSession.close();
        }
    }

}
